package com.qike.huadongexcel;

//import com.spire.xls.FileFormat;
//import com.spire.xls.Workbook;
//import com.spire.xls.Worksheet;

import java.io.*;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

public class ExcelCopy {

    public static void main(String[] args) throws FileNotFoundException, IOException {
//            //加载文档
//            Workbook wb = new Workbook();
////            wb.loadFromFile("test.xlsx");
//            wb.loadFromFile("C:\\Users\\Admin\\Desktop\\华东excel\\project1\\aa.xls");
//
//            //获取第一张工作表
//            Worksheet sheet0 = wb.getWorksheets().get(0);
//        for (Object worksheet : wb.getWorksheets()) {
//            Worksheet worksheet1 = (Worksheet) worksheet;
//            System.out.println(worksheet1.getName());
//        }
//
//            //获取第三张工作表，命名，并将第一张工作表内容复制到该工作表
//            Worksheet sheet2 = wb.getWorksheets().get(1);
//            sheet2.setName("11");
//            sheet2.copyFrom(sheet0);
//
//            //保存文档
//            wb.saveToFile("C:\\Users\\Admin\\Desktop\\华东excel\\project1\\aa.xls",FileFormat.Version2010);
    }



}

